---
title: "SAIF.Business.Claim.Legal stored procedures"
summary: "Oracle stored procedures and packages referenced by this library."
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-31
---

# SAIF.Business.Claim.Legal stored procedures

This page catalogs the Oracle stored-procedure/function members across the 3 packages invoked by this library. **Real Oracle PL/SQL source was retrieved for all three packages via the Legends CLI** (`legends oracle query --owner SAIF --name <package_name>`, schema `WCIS_DBA`) on 2026-08-31: `pk80001_legalnet` and `pk80005_assignment` returned both package specification and body; `pk82289_legalnet_letters` returned only the package specification (no body was available from `DBA_SOURCE`/`ALL_SOURCE` for this package — this is normal/expected for this API, not an error). Every procedure page below documents real signatures, and business rules/operations extracted from actual PL/SQL logic where a body was available, or from the calling VB.NET code (marked inferred) for `pk82289_legalnet_letters`.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`pk80001_legalnet`](pk80001_legalnet.md) | `WCIS_DBA` | Package (98 members) | Legal-case, hearing schedule, appeal, case outcome, case note, file-location, mail-date/OAR, consolidation, and attorney-profile CRUD for the LegalNet module | `clsLegalCase`, `clsLegalSchedule`, `clsAppeal`, `clsCaseOutcome`, `clsCaseNote`, `clsAttorneyProfile`, `clsConsolidations`, `clsLegalFileLocation`, `clsLegalCaseEvaluation`, `clsCaseSearch`, and others |
| [`pk80005_assignment`](pk80005_assignment.md) | `WCIS_DBA` | Package (42 members) | Automated attorney-assignment batch engine: conflict-of-interest/rotation/calendar/caseload checks, assignment result recording, and Outlook/calendar integration queries | `clsAssignmentProcess`, `clsAttorneyConflict`, `clsAttorneySchedule` |
| [`pk82289_legalnet_letters`](pk82289_legalnet_letters.md) | `WCIS_DBA` | Package (4 members, spec only) | Legal letter request selection, worker/claim lookup, and printed-date update for Xpressions letter printing | `clsLetterRequest` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Configuration](../configuration.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.Claim.Legal\LegalNet\`, `SAIF.Business.Claim.Legal\TableMaint\`, `SAIF.Business.Claim.Legal\Print\` (see individual per-package procedure pages for exact referencing call sites)